﻿USE [{0}]


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_CUSTOMER')
	DROP TABLE ODB_CUSTOMER


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_CUSTORDER')
	DROP TABLE ODB_CUSTORDER


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_PREPORDER')
	DROP TABLE ODB_PREPORDER


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_PREPORDERPASS')
	DROP TABLE ODB_PREPORDERPASS


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_PREPORDERWARPLIST')
	DROP TABLE ODB_PREPORDERWARPLIST


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_PRODORDER')
	DROP TABLE ODB_PRODORDER


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_STYLE')
	DROP TABLE ODB_STYLE


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_STYLEWARP')
	DROP TABLE ODB_STYLEWARP


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_STYLEWIDTH')
	DROP TABLE ODB_STYLEWIDTH


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_SUBCUSTORDER')
	DROP TABLE ODB_SUBCUSTORDER


IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_SUBPRODORDER')
	DROP TABLE ODB_SUBPRODORDER

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WARP')
	DROP TABLE ODB_WARP

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WARPSEQ')
	DROP TABLE ODB_WARPSEQ
	
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WARPTYPE')
	DROP TABLE ODB_WARPTYPE

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WARPTYPELIST')
	DROP TABLE ODB_WARPTYPELIST

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WARPYARNLIST')
	DROP TABLE ODB_WARPYARNLIST

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_WEFTYARNLIST')
	DROP TABLE ODB_WEFTYARNLIST

IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME = 'ODB_YARN')
	DROP TABLE ODB_YARN


USE [MASTER]

DROP DATABASE [{0}]